﻿CREATE TABLE [dbo].[Tasks] (
    [Id]       INT            IDENTITY (1, 1) NOT NULL,
    [Name]     NVARCHAR (MAX) NOT NULL,
	[Description] NVARCHAR(MAX) NOT NULL,
	[CreatedDate] datetime NOT NULL,
	[StartDate] datetime NOT NULL,
	[FinishDate] datetime NOT NULL,
	[AuthorId] int NOT NULL,
    [ParentId] INT            NULL,
    [StatusId]   INT  NOT NULL
);

